- 文章信息
- 作者： kaiwu
- 点击数：708
1.九九表
工作簿：http://kaiwu.city/openfiles/excel_reference.xlsx
工作表：30cities
任务：做得快的同学，研究一下如何计算30城市二者之间的距离
=SQRT(POWER(M$2-$I6,2)+POWER(M$3-$J6,2))
2.三种百分比
工作簿：http://kaiwu.city/openfiles/excel_reference.xlsx
工作表：crosstable
3.多选题
工作簿：http://kaiwu.city/openfiles/excel_reference.xlsx
工作表：multi_response
4.数据透视表
分类变量包含标签的Excel文件 (有 variable labels变量名标签和 value labels变量值标签)
http://kaiwu.city/openfiles/data_tourist_with_cnlabels.xlsx
(1)频数分析
性别、
5.VBA
http://kaiwu.city/openfiles/Excel_VBA_example.xlsm
http://kaiwu.city/index.php/vba
- 文章信息
- 作者： kaiwu
- 点击数：477
1.academic database
http://kaiwu.city/index.php/journalcategory
1.1 list of academic database
http://onlinelibrary.wiley.com/
http://www.emeraldinsight.com/
http://www.ebsco.com/index.asp
1.2 collections within academic database
collections for tourism, hospitality, leisure, sport and service
http://kaiwu.city/index.php/journalcategory
journals on service management
http://kaiwu.city/index.php/smjournal
1.3 Journals
SSCI journals for tourism, hospitality, leisure, sport and service
http://kaiwu.city/index.php/sscijournal
https://jcr.clarivate.com/jcr/home
https://lib.dufe.edu.cn/2023/0705/c15a19170/page.htm
http://kaiwu.city/openfiles/HOSPITALITY_LEISURE_SPORT_TOURISM_JCR_JournalResults_09_2024.xlsx
58 SSCI journals + 81 SCI extended journals=139 journals
Google Scholar metrix for tourism and hospitality
http://kaiwu.city/index.php/gs-journal
Top 3
|
Annals of Tourism Research |
ATR |
|
|
Tourism Management |
TM |
|
|
Journal of Travel Research |
JTR |
|
International Journal of Hospitality Management |
IJHM |
|
|
International Journal of Contemporary Hospitality Management |
IJCHM |
|
|
Cornell Hospitality Quarterly |
CHQ |
1.4 academic search engine
scholar's webpage: haiyan song
http://cn.bing.com/academic/profile?mkt=zh-CN&id=2116747243
1.5 books
1.6 fulltexts
http://kaiwu.city/index.php/sci-hub
1.6.1 fulltexts of academic articles
https://sci-hub.se/
https://sci-hub.st/
https://sci-hub.ru/
1.6.2 ebooks
library Genesis
https://libgen.onl/library-genesis/
2.zotero
http://kaiwu.city/index.php/zotero
2.1 install zotero
download zotero
https://www.zotero.org/download/
https://www.zotero.org/download/
https://www.zotero.org/support/installation
https://pureinfotech.com/check-if-processor-arm64-x64-64bit-windows-11/
windows ARM64（64-bit)
http://kaiwu.city/openfiles/Zotero-7.0.5_arm64_setup.exe
windows x64（64-bit)
http://kaiwu.city/openfiles/Zotero-7.0.5_x64_setup.exe
windows x86（32-bit)
http://kaiwu.city/openfiles/Zotero-6.0.35_setup.exe
market share of web browsers
http://kaiwu.city/index.php/desktop-browser-ww-monthly-200901-202108
firefox
https://www.mozilla.org/en-US/exp/firefox/new/
edg
https://www.microsoft.com/en-us/edge
https://www.microsoft.com/zh-cn/edge
https://microsoftedge.microsoft.com/addons/detail/nmhdhpibnnopknkmonacoephklnflpho
4. practice
task01 : amazon
search: the practice of social research
keywords: Aspects of Tourism
https://www.multilingual-matters.com/page/series-results/aspects-of-tourism/
Aspects of Tourism
Chris Cooper (Leeds Beckett University, UK)
C. Michael Hall (University of Canterbury, New Zealand)
Dallen J. Timothy (Arizona State University, USA)
Aspects of Tourism is an innovative, multifaceted series, which comprises authoritative reference handbooks on global tourism regions, research volumes, texts and monographs. It is designed to provide readers with the latest thinking on tourism world-wide and in so doing will push back the frontiers of tourism knowledge. The series also introduces a new generation of international tourism authors writing on leading edge topics.
task02 : goodereads
https://www.goodreads.com/book/show/1430662
task03 : ISBN
http://kaiwu.city/index.php/book-service-management
Service Management: Operations, Strategy, Information Technology
9th Edition
By Sanjeev Bordoloi and James Fitzsimmons and Mona Fitzsimmons
ISBN10: 1259784630
ISBN13: 9781259784637
Copyright: 2019
task04 : DOI
Wang, N. (1999). Rethinking Authenticity in Tourism Experience. Annals of Tourism Research, 26(2), 349–370. https://doi.org/10.1016/S0160-7383(98)00103-0
article: Rethinking Authenticity in Tourism Experience
http://kaiwu.city/index.php/delayed-gratification
http://kaiwu.city/index.php/statistics-for-who-hate
Wang, N. (1999). Rethinking Authenticity in Tourism Experience. Annals of Tourism Research, 26(2), 349–370. https://doi.org/10.1016/S0160-7383(98)00103-0
Wang, N. (1999). Rethinking Authenticity in Tourism Experience. Annals of Tourism Research, 26(2), 349–370. https://doi.org/10.1016/S0160-7383(98)00103-0
Wang, Ning. 1999. “Rethinking Authenticity in Tourism Experience.” Annals of Tourism Research 26 (2): 349–70. https://doi.org/10.1016/S0160-7383(98)00103-0.
Wang, N. (1999) ‘Rethinking Authenticity in Tourism Experience’, Annals of Tourism Research, 26(2), pp. 349–370. doi:10.1016/S0160-7383(98)00103-0.
Wang, Ning. “Rethinking Authenticity in Tourism Experience.” Annals of Tourism Research, vol. 26, no. 2, Apr. 1999, pp. 349–70. ScienceDirect, https://doi.org/10.1016/S0160-7383(98)00103-0.
http://kaiwu.city/index.php/job-ai
task05 : get fulltext from SCI-hub
Wang, N. (1999). Rethinking Authenticity in Tourism Experience. Annals of Tourism Research, 26(2), 349–370. https://doi.org/10.1016/S0160-7383(98)00103-0
Severt, D. E., Tesone, D. V., Bottorff, T. J., & Carpenter, M. L. (2009). A World Ranking of the Top 100 Hospitality and Tourism Programs. Journal of Hospitality & Tourism Research, 33(4), 451–470. https://doi.org/10.1177/1096348009344210
https://sci-hub.se/
https://sci-hub.st/
https://sci-hub.ru/
task06 : download an article from academic database
https://www.sciencedirect.com/
search: tourism and wellbeing
task07 : Zotero retrieve full bibliographic metadata from pdfs
http://kaiwu.city/openfiles/Rickly2022.pdf
http://kaiwu.city/openfiles/severt2009.pdf
z01 : modify folder for zotero
z02 : sort items
z03 : quich search
z04 : take notes
z05 : advanced search
z06 : tags
z07 : create citations and bibliography
z08 : export items
z09 : apps
z10 :add-ons
z11 : run programmes
http://kaiwu.city/index.php/zotero-javascript
book: the pratice of social research
http://kaiwu.city/index.php/10-book-the-practice-of-socia-research
https://book.douban.com/subject/26894285/
classical textbook：The Practice of Social Research
http://kaiwu.city/index.php/book-the-practice-of-socia-research
classical textbook：Research Methods for Business Students
http://kaiwu.city/index.php/book-research-method-for-business
classical textbook
classical textbook: Forty studies that changed psychology
http://kaiwu.city/index.php/40studies-psychology
classical textbook：Service Management: Operations, Strategy, Information Technology
http://kaiwu.city/index.php/book-service-management
classical textbook：Statistics for People Who (Think They) Hate Statistics
http://kaiwu.city/index.php/statistics-for-who-hate
classical textbook：How to Design and Evaluate Research in Education
http://kaiwu.city/index.php/book-how-to-design-and-evaluate-research-in-education
books on Plato's Allegory of the Cave
http://kaiwu.city/index.php/cave
http://kaiwu.city/index.php/theses-collection
- 文章信息
- 作者： kaiwu
- 点击数：213
- 文章信息
- 作者： kaiwu
- 点击数：439
可以通过anaconda安装python（http://kaiwu.city/index.php/python）,操作极为简单；但是anaconda程序很大，而且其包含的python及python拓展模块library不是最新的版本。
直接安装python，并以微软的开源软件 Visual Studio Code（https://code.visualstudio.com/）作为IDE是不错的选择。
微软提供了详细的安装指南
https://docs.microsoft.com/en-us/learn/modules/python-install-vscode/
Get started with Python in Visual Studio
Get started with learning Python by installing and configuring the tools you'll need to build real applications.
Learning objectives
By the end of this module, you'll be able to:
- Install Python 3, if needed.
- Install and configure Visual Studio Code and extensions on your computer.
- Create a Python file.
- Write and run Python code in Visual Studio Code.
Prerequisites
- Ability to install programs locally.
- Basic familiarity with programming concepts.
This module is part of these learning paths
1.安装python
访问python官网，下载安装程序
https://www.python.org/downloads/
2.安装VScode
https://code.visualstudio.com/
3.安装VScode的拓展程序
（1）code runner
（2）python
（3）jupyter notebook
4.以vscode作为IDE，新建、编辑、运行python程序
- 文章信息
- 作者： kaiwu
- 点击数：499
1.ollama
https://github.com/ollama/ollama
https://ollama.com/blog/llama3
用于ollama的模型：
Ollama supports a list of models available on ollama.com/library
Here are some example models that can be downloaded:
| Model | Parameters | Size | Download |
|---|---|---|---|
| Llama 3.2 | 3B | 2.0GB | ollama run llama3.2 |
| Llama 3.2 | 1B | 1.3GB | ollama run llama3.2:1b |
| Llama 3.1 | 8B | 4.7GB | ollama run llama3.1 |
| Llama 3.1 | 70B | 40GB | ollama run llama3.1:70b |
| Llama 3.1 | 405B | 231GB | ollama run llama3.1:405b |
| Phi 3 Mini | 3.8B | 2.3GB | ollama run phi3 |
| Phi 3 Medium | 14B | 7.9GB | ollama run phi3:medium |
| Gemma 2 | 2B | 1.6GB | ollama run gemma2:2b |
| Gemma 2 | 9B | 5.5GB | ollama run gemma2 |
| Gemma 2 | 27B | 16GB | ollama run gemma2:27b |
| Mistral | 7B | 4.1GB | ollama run mistral |
| Moondream 2 | 1.4B | 829MB | ollama run moondream |
| Neural Chat | 7B | 4.1GB | ollama run neural-chat |
| Starling | 7B | 4.1GB | ollama run starling-lm |
| Code Llama | 7B | 3.8GB | ollama run codellama |
| Llama 2 Uncensored | 7B | 3.8GB | ollama run llama2-uncensored |
| LLaVA | 7B | 4.5GB | ollama run llava |
| Solar | 10.7B | 6.1GB | ollama run solar |
Note
You should have at least 8 GB of RAM available to run the 7B models, 16 GB to run the 13B models, and 32 GB to run the 33B models.
2.中文相关的几个模型
2.1 llama2-chinese
https://ollama.com/library/llama2-chinese
ollama run llama2-chinese
2.2 qwen
https://ollama.com/library/qwen
阿里云的千问模型
ollama run qwen
2.3 yi
Yi 是百度的大语言模型
https://ollama.com/library/yi:34b
https://huggingface.co/01-ai/Yi-34B
ollama run yi
ollama run yi:9b
ollama run yi:34b
3.图形界面
https://github.com/fmaclen/hollama
一个用于与 Ollama 服务器对话的简约网页界面。
功能特点：
- 大型提示字段
- 支持语法高亮的 Markdown 渲染
- 代码编辑器功能
- 可定制的系统提示
- 复制代码片段、消息或整个会话
- 编辑并重试消息
- 数据本地存储在您的浏览器上
- 响应式布局
- 浅色和深色主题
- 多语言界面
- 直接从界面下载 Ollama 模型
 |
|---|
4.移动应用app
Pocketpal这个app可以下载LLama模型，可以在没有联网的情况下（手机本地环境）进行类似于chat GPT的问答
https://github.com/Anicodeth/Pocketpal/tree/main/Mobile
https://github.com/a-ghorbani/PocketPal-feedback
https://play.google.com/store/apps/details?id=com.pocketpalai
